<?php 
require_once("../include/conn.php");
require_once("../include/page.php");
$table=$tb_rk;

$page=$_GET['page'];
$perpage=20;
$sql_all="select count(*) from   $table  where `isdel`='0'  ";
$con   =   mysql_db_query($db_name,$sql_all);   
$num   =   mysql_result($con,0);   //   统计当前总的记录数   
$list=new page($num,$page,$perpage);  
$strartrow=$list->getStartRow();
$sql   =   "select   *   from    $table  where `isdel`='0'  order  by   id   DESC   limit $strartrow,$perpage";   //从上面的起点开始查询出20条数据   
$cn_ma   =   mysql_db_query($db_name,$sql);  
?>
<html>
<head>
<title>生产日况信息</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="Admin_Style.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="2" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%"  border="0" cellpadding="0" cellspacing="2">
  <tr class="topbg">
    <th colspan="4">生产日况信息</th>
  </tr>
  <tr>
    <td width="28%">&nbsp;</td>
    <td width="32%">&nbsp;</td>
    <td width="24%">&nbsp;</td>
    <td width="16%">&nbsp;</td>
  </tr>
  <tr class="tdbg">
    <td>标题</td>
    <td>日期</td>
    <td>操作</td>
    <td>&nbsp;</td>
  </tr>
  <?php
   while($row_rk = mysql_fetch_array($cn_ma))
   {	
	
	?>
  <tr class="tdbg">
    <td><?php echo $row_rk[title]; ?></td>
    <td><?php
	 $row_rk[tdate]=substr($row_rk[tdate],5);
		echo $row_rk[tdate];
?></td>
    <td><a href="scrk_update.php?id=<?=$row_rk[id];?>">修改</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <a href="Admin_del.php?id=<?=$row_rk[id];?>&action=delete&name=1" title="删除了还可以从回收站找回来!">临时删除</a>&nbsp;&nbsp;&nbsp;&nbsp;
    <a href="Admin_del.php?id=<?=$row_rk[id];?>&action=pack&name=1" title="千万要注意哟,删除了就找不回来了!">永久删除</a></td>
    <td>&nbsp;</td>
  </tr>
  <?php }?>
  <tr align="center">
  <td colspan="4" style="font-size:20px;"><?php echo $list->showPageList()?>  </td>
</tr>  
</table>
</body>
</html>
